UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'g8eHM7lf/1x8q0Q8t1a7suuKia5/32rMGsTBWEwbBfE=' 
WHERE 
  key_id = '4c1be2a438a75ca3cdc3a7115b7b4751fa4e4fc0379d33200dd79dd95016e39c' 
  AND (
    token = 'g8eHM7lf/1x8q0Q8t1a7suuKia5/32rMGsTBWEwbBfE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00046