UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'jgLuKJaIc0mSzAhsPLF0Xw5Z+RUccVeD0JpcZuLSYFc=' 
WHERE 
  key_id = 'af55c8ad5d15cb7ce987991fe2fb594aaf69c91bf04366140a001544baf6beb0' 
  AND (
    token = 'jgLuKJaIc0mSzAhsPLF0Xw5Z+RUccVeD0JpcZuLSYFc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043