UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'L1eUd6hiXMB8AA0mmCDg2uOGZ/hPniil5HjANm6Maj8=' 
WHERE 
  key_id = 'bf6037db36b9735d8bc177a061c71120530038e6420eb41589aa6b5d05aa4b70' 
  AND (
    token = 'L1eUd6hiXMB8AA0mmCDg2uOGZ/hPniil5HjANm6Maj8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00048