UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YCcV7aQjJy9U1mSLzvyApORN2WlWiR8U6opEXGpTMYk='
WHERE
key_id = '0b0fb34a06144d34cae5872ab04b966b6e823ab34a4b9c24e61a99b6d770ed92'
AND (
token = 'YCcV7aQjJy9U1mSLzvyApORN2WlWiR8U6opEXGpTMYk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)