UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zYdqiLFqHJphdb0FbKtcOw6LBmC4sXvxmyU5v30V0QI='
WHERE
key_id = '3094a00c7b49847a70fcc125197f3217dc91f68d846f212df904138e0ffa421f'
AND (
token = 'zYdqiLFqHJphdb0FbKtcOw6LBmC4sXvxmyU5v30V0QI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)