UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0J9LE7/cz8AJkc9zfFNDB6mVBI7+T2YCCt5iYr7yiZY='
WHERE
key_id = 'f5bba8d411cde1b7d7580ebe101713768575171ef0f1bbb83880de4973d76c47'
AND (
token = '0J9LE7/cz8AJkc9zfFNDB6mVBI7+T2YCCt5iYr7yiZY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)