UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'xg8sOiWZyhe02GO/Zqp8rh6tfyc90szznu5dt4vRJp8=' 
WHERE 
  key_id = '25adf7137bc153a30aa697eb70568f4d4cde0c25dd6d5990d95403ffbf77be96' 
  AND (
    token = 'xg8sOiWZyhe02GO/Zqp8rh6tfyc90szznu5dt4vRJp8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021