UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9Kj0DqcHiYPefU/o1848gwKJC6reX3Wmycrsh6WH4jY='
WHERE
key_id = '0bf39ec84beecc40c4fb111d05167563fff146fe62c1a4c9ba076ab931d53f99'
AND (
token = '9Kj0DqcHiYPefU/o1848gwKJC6reX3Wmycrsh6WH4jY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)