UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GRc9fQGz8pHW0+oKiLcQKElHbIwSDYENDMu9yFqlsKc='
WHERE
key_id = 'b8dbcc04a57be9d7d2be98b6f9299fee92eaed6805adf362ed2d0c0f6454acb5'
AND (
token = 'GRc9fQGz8pHW0+oKiLcQKElHbIwSDYENDMu9yFqlsKc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)