UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QyGEzljO71q9su1it7aq5ZyvxkK12lOxOD2MxpEKsj0='
WHERE
key_id = '83f96d4b122941219e29ff6633a377042a9080d3812d07713369005a8ba0efe7'
AND (
token = 'QyGEzljO71q9su1it7aq5ZyvxkK12lOxOD2MxpEKsj0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)