UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VvgZhdkIZkO0VVAXOM2k5QLsg17DefCK8V0oYySUhNw='
WHERE
key_id = 'c8c7be3ab22b95155abde1f59f71dc8083f04c4dc8c4ce3c61f59c840431bfa3'
AND (
token = 'VvgZhdkIZkO0VVAXOM2k5QLsg17DefCK8V0oYySUhNw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)