UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NOP+w7hDKrlfeVTIavjcN027f/RgWIE6rCHeFU9x1Rw='
WHERE
key_id = '85851a87fd9cb4112193f858fb821aa87102c4928f32ef6330a7af5cca606975'
AND (
token = 'NOP+w7hDKrlfeVTIavjcN027f/RgWIE6rCHeFU9x1Rw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)