UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5a4JFcmxlhKZS3AJi+YIBOcldkNfrTc9sYMStk7PszY='
WHERE
key_id = '1a2c84e5a92f0d65fbd00d7010865ffaf8a7964fdd12f881bf6752ea561df676'
AND (
token = '5a4JFcmxlhKZS3AJi+YIBOcldkNfrTc9sYMStk7PszY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)