UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sDp1yz8po1bmDXFF51oddJgH0KQeS+rJhxk/L7bxoVU='
WHERE
key_id = '055ec0efdebeb82ee176c0ad630a287f06917c2aeb7ffba61de75b6236ea00cb'
AND (
token = 'sDp1yz8po1bmDXFF51oddJgH0KQeS+rJhxk/L7bxoVU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)