UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '9coAVeeO6ibk1uiVdKtN1x3FDLyRQfGvbrIZC6BxMfo=' 
WHERE 
  key_id = 'a9cef3d34fa4d67147dfc0e9d0b1db2d67751f2b86dcbea77cc8e43aa6b0dda7' 
  AND (
    token = '9coAVeeO6ibk1uiVdKtN1x3FDLyRQfGvbrIZC6BxMfo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00019