UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9XpX5a2DMLxkv7mi9mBT2RwZ6fxi3i8rDoAoig0grA0='
WHERE
key_id = '02a9d46aa5477a62bc51eabb5e20c454892429eb867fd75a79d75ffb4672661f'
AND (
token = '9XpX5a2DMLxkv7mi9mBT2RwZ6fxi3i8rDoAoig0grA0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)