UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1U7gg6fsaBrWqDIaXx7L1xauQ0PkBa91vW/RwAnNOGc='
WHERE
key_id = '1a0b42757737fb10208419b0768abdffce2dc76e213e9a51161f376a5beff635'
AND (
token = '1U7gg6fsaBrWqDIaXx7L1xauQ0PkBa91vW/RwAnNOGc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)