UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xKH1Zd3cdI8JLVL3/qztzLHhpF6GT9fn0gGIQBEcPOM='
WHERE
key_id = 'c00511a57a70804d01de90741946ecd71de122fbeb380f456165a7ab520b804d'
AND (
token = 'xKH1Zd3cdI8JLVL3/qztzLHhpF6GT9fn0gGIQBEcPOM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)