UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cN2BYKr41PylZQb3f+4naq8oDqoEUf7O4WqvMRu31dw='
WHERE
key_id = '9d44d7bcb25af3eb6c5a487a87cb909b033f6520f334a226437606e89c4fbac9'
AND (
token = 'cN2BYKr41PylZQb3f+4naq8oDqoEUf7O4WqvMRu31dw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)