UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1fwYPnOuy1A3YVAdjP6Ve8yY83HiIuVI+BStkThuiUk='
WHERE
key_id = 'f8c929060a154c83e4acf5d4a7c897ae94c2e4d55bf1d9f9539d316214fbcb70'
AND (
token = '1fwYPnOuy1A3YVAdjP6Ve8yY83HiIuVI+BStkThuiUk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)