UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zgYXG4CJEyCwpIFeJ1fNLPNkkb5U9uUVKcp+y33b8sA='
WHERE
key_id = '8a5fea1ff68890114423ec9546363ea5f344b2d7edf961a22e2d5ef37fe7e2d6'
AND (
token = 'zgYXG4CJEyCwpIFeJ1fNLPNkkb5U9uUVKcp+y33b8sA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)