UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '4Wvk2HQeJRpCqrTLs1BKBrq2OEm1rEnV26LzZ6v2cFU=' 
WHERE 
  key_id = '6c3eb63b9e91277000fad3b1863331775829099d61a9cd98cf6e9065652eb6dd' 
  AND (
    token = '4Wvk2HQeJRpCqrTLs1BKBrq2OEm1rEnV26LzZ6v2cFU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00039