UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L7Abk2YCAkM2oX4wslsHSEDuwRXemdrX2+Etl5B7Sbc='
WHERE
key_id = 'ebb585db05a3123e8d880a0c0506b6ed32821f1167cce6e3aebcf3100bd91975'
AND (
token = 'L7Abk2YCAkM2oX4wslsHSEDuwRXemdrX2+Etl5B7Sbc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)