UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ydM7L85fbVx4Err8oHJQZCyGu/E5bYg8Yu86/17sVrU='
WHERE
key_id = '5a7af250b8b69d3485f01647d85a248ea4a867b875b398589c998cf9829b35ff'
AND (
token = 'ydM7L85fbVx4Err8oHJQZCyGu/E5bYg8Yu86/17sVrU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)