UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zM9jbPhLYfWHglctKJ5oT3769xORg3uY+UHk9mDFpMw='
WHERE
key_id = '2281007f24df678b0fc5e9cc1f65e0b7361ab2cc9686c6c6eaa375057715cfa5'
AND (
token = 'zM9jbPhLYfWHglctKJ5oT3769xORg3uY+UHk9mDFpMw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)