UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XI9uE8LwfeFJZ7WCKzggJPnN61CLtS4ipQzfc/XvGpY='
WHERE
key_id = '514b4dc46a85588680a5558050db61bb185457baea75731deeb51956382ba9f4'
AND (
token = 'XI9uE8LwfeFJZ7WCKzggJPnN61CLtS4ipQzfc/XvGpY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)