UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4E+NfbQE1ISTEvHC4Be75U8nn+aU7kh+6UF8XftHspk='
WHERE
key_id = 'f7c47375d8140e867680d88b6b400035423cc4bb1f5fcc3a482dae82f07ce55d'
AND (
token = '4E+NfbQE1ISTEvHC4Be75U8nn+aU7kh+6UF8XftHspk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)