UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zcmpn9QSMhsSlUsl2+lOmEonIgPmOGMySqQDYKlUcwY='
WHERE
key_id = '7bee7aa7e821785b8f43e7bf156c863064b410717d7676263c1132f2ea9ebb32'
AND (
token = 'Zcmpn9QSMhsSlUsl2+lOmEonIgPmOGMySqQDYKlUcwY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)