UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u8oTNy47wMO+OaAyQUHDrgBMNDDRF4lWlZ0iLfREmGY='
WHERE
key_id = '100b49b1b7b12fac4e45e68089f78bc39059c1221496aed708d10c1839917323'
AND (
token = 'u8oTNy47wMO+OaAyQUHDrgBMNDDRF4lWlZ0iLfREmGY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)