UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9UrMsJrUuzKklUoMG99J9X7jFSUimZ2BBs+IRvYj1h4='
WHERE
key_id = '3a00b7136617af19928183691c496c938e8e20f7a1dfcb771d7eca6116d57007'
AND (
token = '9UrMsJrUuzKklUoMG99J9X7jFSUimZ2BBs+IRvYj1h4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)