UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C8KYabQGzdCSTWCbPFEG3wMQYDddqDnjxOBJYIbdWz0='
WHERE
key_id = '8b4665e38e7ff36a799d000cb9305bd0e28cb1418aebc0b2b396764023db6d8b'
AND (
token = 'C8KYabQGzdCSTWCbPFEG3wMQYDddqDnjxOBJYIbdWz0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)