UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IZjCWD6oTaxMqfuOBUHzD5MR7YdUKAZrPXr6budZFdU='
WHERE
key_id = '2cfe281b3f4ac5030be26f7c1f1f05f3c1375a308327daebfac37197d3312a9f'
AND (
token = 'IZjCWD6oTaxMqfuOBUHzD5MR7YdUKAZrPXr6budZFdU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)