UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/IhzBQkUIV1uZaYPxdK7cSCSklCZhv8LS58PYpjqXL4='
WHERE
key_id = '46aa01e544252477db0f9a568e6baa07dfc9e021f710bb79435a210ab603e524'
AND (
token = '/IhzBQkUIV1uZaYPxdK7cSCSklCZhv8LS58PYpjqXL4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)