UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pvdN08xW/Kdvu+4OU1TIfK4+JErZjQvc0j8AFkMFsPY='
WHERE
key_id = '0a378a2c14b5b3fa404dc668b4d796aa19af776b6f4f5236eb06a8cb5fe78815'
AND (
token = 'pvdN08xW/Kdvu+4OU1TIfK4+JErZjQvc0j8AFkMFsPY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)